Application Research on DML Triggers in Maintaining Database Integrity

doi:10.3969/j.issn.1006-2475.2013.04.014

Computer and Modernization ›› 2013, Vol. 1 ›› Issue (4): 57-59.doi: 10.3969/j.issn.1006-2475.2013.04.014

• 软件工程 • Previous Articles Next Articles

Application Research on DML Triggers in Maintaining Database Integrity

CHU Long-xian

Software College, Pingdingshan University, Pingdingshan 467000, China

Received:2012-12-11 Revised:1900-01-01 Online:2013-04-17 Published:2013-04-17

Abstract

Abstract: Frequently updating data may undermine the integrity of database, and trigger properly designed can protect data effectively. The paper discusses the basic steps of data integrity control mechanism according to DML trigger technology in SQL Server 2005. It focuses on DML trigger work principle and implementation process with examples of triggers design. The test results show that the application of trigger improves the system performance and maintains the integrity of database.

Key words: database, integrity, trigger, SQL Server

CLC Number:

TP311

CHU Long-xian. Application Research on DML Triggers in Maintaining Database Integrity[J]. Computer and Modernization, 2013, 1(4): 57-59.

[1]	ZHANG Li, LUO Chun-shan, XIE Wei-yuan, LI Bei-bei. Adaptive Encryption Method for Private Database Based on Branch Obfuscation Algorithm [J]. Computer and Modernization, 2022, 0(03): 43-47.
[2]	LI Wen-quan, XU Su-ping. Tourism Resource Information Database System Based on Geographic Information [J]. Computer and Modernization, 2021, 0(08): 100-103.
[3]	LEI Ming, ZHAO Yu-juan, JIANG Han-sheng, WU Guo-liang, LIANG Jian. Construction of Meteorological System Data Service Platform Based on Distributed Technology [J]. Computer and Modernization, 2020, 0(11): 56-59.
[4]	LI Xi-min, LI Shu-qi. Automatic Processing Method for Cache Conflict of Multi-source Database Based on Rough Set [J]. Computer and Modernization, 2020, 0(10): 36-39.
[5]	ZHANG Xi, WANG Jian. A Public Integrity Auditing Scheme Based on Blind Signature for Shared Data in Cloud [J]. Computer and Modernization, 2020, 0(04): 60-.
[6]	FANG Zhou, CHENG Qing, PEI Xu-bin . Data Security Protection of Electricity Marketing Information System [J]. Computer and Modernization, 2019, 0(03): 111-.
[7]	XIEBin-ming,WANGXiao-dong. StorageReplication Technologyof Heterogeneous Database#br# in Regional Network [J]. Computer and Modernization, 2018, 0(07): 1-.
[8]	JIPeng1,2,LIHui1,2,CHENMei1,2,DAIZhen-yu1,2. DoFFT:AFastFourierTransformMethodBasedonDistributedDatabase [J]. Computer and Modernization, 2018, 0(06): 19-.
[9]	ZHOUPeng1,2，LONGShi-gong1,2. CloudDataIntegrityBasedonSBTTotalNodeStorage [J]. Computer and Modernization, 2018, 0(06): 37-.
[10]	HUANG Shu-juan1, ZHU Yi-an2, GAO Wu-qi1, LUO Jun-min1. Dual Triggered Security Access Mechanism for Embedded System Kernel [J]. Computer and Modernization, 2018, 0(05): 79-.
[11]	LIU Yan-ping. Method of Developing Database Driven by Golang [J]. Computer and Modernization, 2018, 0(01): 113-115.
[12]	QI Bin. Design and Implementation of Data Acquisition System of Networked Database [J]. Computer and Modernization, 2017, 0(5): 71-75.
[13]	LIU Si-tong1, LUO Jun1, ZHAN Huo-mu2. Research on Mapping and Storing OWL File to Relational Database [J]. Computer and Modernization, 2017, 0(5): 83-87.
[14]	LIU Qun1,2, SONG Qianyi2, CHANG Yong1,2, YANG Jianxu1,2. Design of Unified Commercial Database Management [J]. Computer and Modernization, 2017, 0(3): 109-.
[15]	DAI Sheng, WANG Bo. Relational Query in Large-scale Configuration Management Database Based on Graph Database [J]. Computer and Modernization, 2017, 0(1): 51-56.

Application Research on DML Triggers in Maintaining Database Integrity

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics

Comments